﻿CREATE TABLE [dbo].[CLM_837I_1000A_Submitter]
(
[NM101_SubmitterEntityIdentifierCode] [nvarchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NM102_SubmitterEntityTypeQualifier] [nvarchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NM103_SubmSubmitter_itterLastOrOrganizationName] [nvarchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NM104_SubmitterFirstName] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NM105_SubmitterMiddleName] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NM108_SubmitterIdentificationCodeQualifier] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NM109_SubmitterIdentifier] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PER01_1SubmitterContactFunctionCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PER02_1SubmitterContactName] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PER03_1SubmitterCommunicationNumberQualifier1] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PER04_1SubmitterCommunicationNumber1] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PER05_1SubmitterCommunicationNumberQualifier2] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PER06_1SubmitterCommunicationNumber2] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PER07_1SubmitterCommunicationNumberQualifier3] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PER08_1SubmitterCommunicationNumber3] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PER01_2SubmitterContactFunctionCode] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PER02_2SubmitterContactName] [nvarchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PER03_2SubmitterCommunicationNumberQualifier1] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PER04_2SubmitterCommunicationNumber1] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PER05_2SubmitterCommunicationNumberQualifier2] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PER06_2SubmitterCommunicationNumber2] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PER07_2SubmitterCommunicationNumberQualifier3] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PER08_2SubmitterCommunicationNumber3] [nvarchar] (80) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DateProcessed] [datetime] NULL,
[IDKey] [int] NOT NULL IDENTITY(1, 1),
[BTSMessageID] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BTSInterchangeID] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]


